SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweConcursosGanados
AS
SELECT IdConcursoGanado AS ID, Agente, Descripcion, Cargo, Asignatura, Fecha, TipoConcurso, TipoConvocatoria, GrupoIncumbencias, 
               FechaPresentacion
FROM  dbo.tb_ConcursosGanados
GO
GRANT SELECT ON  [dbo].[vweConcursosGanados] TO [Juntas]
GRANT INSERT ON  [dbo].[vweConcursosGanados] TO [Juntas]
GRANT DELETE ON  [dbo].[vweConcursosGanados] TO [Juntas]
GRANT UPDATE ON  [dbo].[vweConcursosGanados] TO [Juntas]
GRANT SELECT ON  [dbo].[vweConcursosGanados] TO [MCEEjecutivo]
GRANT SELECT ON  [dbo].[vweConcursosGanados] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vweConcursosGanados] TO [SoloVer]
GO
